﻿CREATE PROCEDURE [dbo].[GetCustomerHoursByConsultant]
@customerUID INT, @startDate DATETIME, @endDate DATETIME
AS
select  ProjectName,UserName,EntryDate as Date, EntryDuration as Hours from vwCustomerProjectHours
where EntryDate >= @startDate and EntryDate <= @endDate  and CustomerID=@customerUID
order by ProjectName,UserName


